Scalar-valued Functions [dbo].[asi_GetWorkflowInstanceLockDuration]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
SQL Script
create function [dbo].[asi_GetWorkflowInstanceLockDuration]()
returns int
as
begin
declare @duration int

select  @duration = convert(int, ParameterValue)
from    SystemConfig
where    ParameterName = 'WorkflowInstanceLockDuration'

if @duration is null
   set @duration = 30

return(@duration)
end

GO
Uses
Used By